home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
AOL File Library: 2,801 to 2,900
/
aol-file-protocol-4400-2801-to-2900.zip
/
AOLDLs
/
TAWUG
/
TAWUG Disk No. 17 (SHK)
/
TAWUG.17
/
TAWUG8511A
(
.txt
)
< prev
next >
Wrap
AppleWorks Document
|
1985-12-14
|
6KB
|
95 lines
O===================|===================|===================|====================
December 8, 1985
The APPLEWORKS USERS GROUP
Jim Willis, HCOIC
1300 Hinton St.
West Monroe, LA 71291
Hi Jim;
II just purchased the first twelve disks of TAWUG, from the Big Red Apple M
KClub. Although I have gone through all twelve, I will be gleaning gems for E
Cmany days and weeks. Congratulations on the great job you and your =
contributors have done. That was the best $13 I ever spent.
MLet me introduce myself. I have had my Apple//c since January of this year. N
LAt the time of purchase, I wanted to use it with Appleworks (wordprocessing K
Iand data base, esp.) and for home accounting, Dollars and $ense. I also K
Ibought a second disk drive, Oki/Imagewriter printer and a mouse. In the G
Eeleven months since then, I have added a modem and joined CompuServe J
H(72447,602) and DELPHI (IDA); joined IAC and CALL A.P.P.L.E. My latest I
Gaddition is a Princeton HX-12 after installing a Vidio 7 color //c and
mappler. Color is terrific!!
JWhy? Well, I am 52 years young, mother of three children now out on their M
Kown. My daughter is studying computer programming and CAD in the state of M
KWashington in connection with her job. I could see where I was being left P
Nbehind in more ways than one. I wanted to keep up with technology and having <
computer literacy seemed like one way of hanging in there.
LI work full-time as a bookkeeper for a local lumber and hardware store. We M
Kdo not have a computer in our office, but I am working on it. There are so O
Mmany ways a computerized office would save time and money. But the building K
Iindustry and our farm economy is very depressed (I live in North
Dakota, P
Nremember; if the farmer is prosperous, so is all of North
Dakota) and for the M
Kmoment it is a loosing game. Deciding to show my boss what a computer can P
Ndo,I put our sales on a spreadsheet and printed it for him. He was impressed N
Lbut until the economy turns around, computers will have to wait. Meanwhile, P
Nhe had me do spreadsheets of our sales for the last five years. Don't worry I ,
kept track of my time and was paid for it.
NI am Conference President of about 3000 American Lutheran Church Women in our M
Karea. I have set up a data base of the 300 officers in our conference and Q
Odistrict. I use the wordprocessor for letters and use AMP to mailmerge them. E
CWe also write a newsletter and handbooks for training seminars and L
Jconventions. DJ Lane's
Double Column Formatting
is going to be a great
help.
LI am sending you the spreadsheet form that could be used for other accruals N
Lbeside sales. The formulas add each of the first six months data for a six K
Imonth total; each month after the sixth is shown in the second six month O
Mtotal and the year end total is recalculated after each months entry. So you O
Malways have a year to date total that is current. Each column down adds the L
Jtype of sale into a sub-total that is included in the monthly total. The M
Ktotal for Taxable Sales I have continued to figure separately and enter as N
Ldata only. State taxes vary too much and I haven't tried to enter a formula P
Nyet, but it wouldn't be impossible. The titles are protected, to change them M
Kuse @T (open-apple t), use same to protect them after changing, by placing N
Lcursor at topmost, leftmost position, under and to the right of the labels. I
G(On this example, to the left of Cash Sales and in July column.) Press G
EOpen-Apple T and when asked, move cursor to BOTH, now the labels are C
protected and will follow you as you move across the spreadsheet.
LWhen I first used this protection, I panicked when I tried to move into the O
Mprotected area and saw what looked like extra titles appearing on the form. M
KThis is only an optical illusion and if you move the cursor down or to the P
Nright, eventually everything will look normal, until you try to move into the O
Mprotected area again. Carole Matthews' book
APPLE WORKS MADE EASY
has been '
a great help in setting up this form.
IOne more thing, the automatic recalculation is off; to recalculate after "
entering data, use Open-Apple K.
NI was going to send a copy of my data base on the officers in the church work N
Lthat I do, but have decided to give a tip instead. We have three levels of L
JOfficers in our District and at different times must send a letter to one L
Jtype or an other. So each is coded not only by the office she holds, but H
Falso by the level she is. Now for a letter to local Presidents, I use O
Mopen-apple F and type L.Pres.....and there is my mailing list. The process J
His the same for a list of conference Vice-Presidents (C.VP) or district ?
Secretary (D.Sec) or whatever group of officers I might need.
MThis way I only have to maintain one data base, but I can pull out any group N
Lof officers that I need with a couple of key strokes. Also, by using coding P
Nin listing each congregation, I can call up a list of all the officers in one <
particular parish.
APPLEWORKS,
you're the GREATEST!!!
TIP:
Before you set up a database, try to imagine all the different lists P
Nthat you might want or need to compile from the database. Include catagories C
that can be searched for a partial listing for a particular need.
Please include me on your membership list. I look forward to the next disks.I
GThis disk can be overwritten for the next issue. Sure am glad to have
"discovered" you.
Sincerely,
Marie Lewis
Rt 1 Box 101
Douglas, ND 587354
Telephone: 701-852-3151 (work),701-722-3588 (home)